Tabela DocumentData

Definicja tabeli DocumentData

Name

DocumentData

Code

DocumentData

Comment

PL: Archiwum dokumentów
EN: Document's archive


Lista kolumn tabeli DocumentData

Name

Code

DocumentDataID

DocumentDataID

DocumentID

DocumentID

PayerDataID

PayerDataID

SellerDataID

SellerDataID

Seller1Name

Seller1Name

Seller1TaxPayerID

Seller1TaxPayerID

Seller1Street

Seller1Street

Seller1PostOffice

Seller1PostOffice

Seller1Place

Seller1Place

Seller1Country

Seller1Country

Seller1Phone

Seller1Phone

Seller1Fax

Seller1Fax

Seller2Name

Seller2Name

Seller2TaxPayerID

Seller2TaxPayerID

Seller2Street

Seller2Street

Seller2PostOffice

Seller2PostOffice

Seller2Place

Seller2Place

Seller2Country

Seller2Country

Seller2Phone

Seller2Phone

Seller2Fax

Seller2Fax

ContractorName

ContractorName

ContractorTaxPayerID

ContractorTaxPayerID

ContractorStreet

ContractorStreet

ContractorPostOffice

ContractorPostOffice

ContractorPlace

ContractorPlace

ContractorCountry

ContractorCountry

ContractorPhone

ContractorPhone

ContractorFax

ContractorFax

PaymentType

PaymentType

InsertingPersonName

InsertingPersonName

PatientNo

PatientNo

MainBookNo

MainBookNo

HospitalOrderNo

HospitalOrderNo

PatientName

PatientName

Active

Active

InsertDate

InsertDate

ContractNo

ContractNo

ExternalContractNo

ExternalContractNo

BankAccountID

BankAccountID

BankName

BankName

AccountNo

AccountNo

ContractorCompanyStatisticalNo

ContractorCompanyStatisticalNo

ContractorNationalIdNo

ContractorNationalIdNo

OrdererDataId

OrdererDataId


Kolumna DocumentDataID tabeli DocumentData

Definicja kolumny DocumentDataID tabeli DocumentData

Name

DocumentDataID

Code

DocumentDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DocumentID tabeli DocumentData

Definicja kolumny DocumentID tabeli DocumentData

Name

DocumentID

Code

DocumentID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PayerDataID tabeli DocumentData

Definicja kolumny PayerDataID tabeli DocumentData

Name

PayerDataID

Code

PayerDataID

Data Type

NUMBER(15)

Mandatory

No

Comment

ID danych platnika z faktury


Kolumna SellerDataID tabeli DocumentData

Definicja kolumny SellerDataID tabeli DocumentData

Name

SellerDataID

Code

SellerDataID

Data Type

NUMBER(15)

Mandatory

No

Comment

ID sprzedawcy


Kolumna Seller1Name tabeli DocumentData

Definicja kolumny Seller1Name tabeli DocumentData

Name

Seller1Name

Code

Seller1Name

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Seller1TaxPayerID tabeli DocumentData

Definicja kolumny Seller1TaxPayerID tabeli DocumentData

Name

Seller1TaxPayerID

Code

Seller1TaxPayerID

Data Type

VARCHAR2(15)

Mandatory

No

Comment

NIP


Kolumna Seller1Street tabeli DocumentData

Definicja kolumny Seller1Street tabeli DocumentData

Name

Seller1Street

Code

Seller1Street

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna Seller1PostOffice tabeli DocumentData

Definicja kolumny Seller1PostOffice tabeli DocumentData

Name

Seller1PostOffice

Code

Seller1PostOffice

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller1Place tabeli DocumentData

Definicja kolumny Seller1Place tabeli DocumentData

Name

Seller1Place

Code

Seller1Place

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna Seller1Country tabeli DocumentData

Definicja kolumny Seller1Country tabeli DocumentData

Name

Seller1Country

Code

Seller1Country

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller1Phone tabeli DocumentData

Definicja kolumny Seller1Phone tabeli DocumentData

Name

Seller1Phone

Code

Seller1Phone

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller1Fax tabeli DocumentData

Definicja kolumny Seller1Fax tabeli DocumentData

Name

Seller1Fax

Code

Seller1Fax

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller2Name tabeli DocumentData

Definicja kolumny Seller2Name tabeli DocumentData

Name

Seller2Name

Code

Seller2Name

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Seller2TaxPayerID tabeli DocumentData

Definicja kolumny Seller2TaxPayerID tabeli DocumentData

Name

Seller2TaxPayerID

Code

Seller2TaxPayerID

Data Type

VARCHAR2(15)

Mandatory

No

Comment

NIP


Kolumna Seller2Street tabeli DocumentData

Definicja kolumny Seller2Street tabeli DocumentData

Name

Seller2Street

Code

Seller2Street

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna Seller2PostOffice tabeli DocumentData

Definicja kolumny Seller2PostOffice tabeli DocumentData

Name

Seller2PostOffice

Code

Seller2PostOffice

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller2Place tabeli DocumentData

Definicja kolumny Seller2Place tabeli DocumentData

Name

Seller2Place

Code

Seller2Place

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna Seller2Country tabeli DocumentData

Definicja kolumny Seller2Country tabeli DocumentData

Name

Seller2Country

Code

Seller2Country

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller2Phone tabeli DocumentData

Definicja kolumny Seller2Phone tabeli DocumentData

Name

Seller2Phone

Code

Seller2Phone

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller2Fax tabeli DocumentData

Definicja kolumny Seller2Fax tabeli DocumentData

Name

Seller2Fax

Code

Seller2Fax

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna ContractorName tabeli DocumentData

Definicja kolumny ContractorName tabeli DocumentData

Name

ContractorName

Code

ContractorName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ContractorTaxPayerID tabeli DocumentData

Definicja kolumny ContractorTaxPayerID tabeli DocumentData

Name

ContractorTaxPayerID

Code

ContractorTaxPayerID

Data Type

VARCHAR2(15)

Mandatory

No

Comment

NIP


Kolumna ContractorStreet tabeli DocumentData

Definicja kolumny ContractorStreet tabeli DocumentData

Name

ContractorStreet

Code

ContractorStreet

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna ContractorPostOffice tabeli DocumentData

Definicja kolumny ContractorPostOffice tabeli DocumentData

Name

ContractorPostOffice

Code

ContractorPostOffice

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna ContractorPlace tabeli DocumentData

Definicja kolumny ContractorPlace tabeli DocumentData

Name

ContractorPlace

Code

ContractorPlace

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna ContractorCountry tabeli DocumentData

Definicja kolumny ContractorCountry tabeli DocumentData

Name

ContractorCountry

Code

ContractorCountry

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna ContractorPhone tabeli DocumentData

Definicja kolumny ContractorPhone tabeli DocumentData

Name

ContractorPhone

Code

ContractorPhone

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna ContractorFax tabeli DocumentData

Definicja kolumny ContractorFax tabeli DocumentData

Name

ContractorFax

Code

ContractorFax

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna PaymentType tabeli DocumentData

Definicja kolumny PaymentType tabeli DocumentData

Name

PaymentType

Code

PaymentType

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna InsertingPersonName tabeli DocumentData

Definicja kolumny InsertingPersonName tabeli DocumentData

Name

InsertingPersonName

Code

InsertingPersonName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna PatientNo tabeli DocumentData

Definicja kolumny PatientNo tabeli DocumentData

Name

PatientNo

Code

PatientNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna MainBookNo tabeli DocumentData

Definicja kolumny MainBookNo tabeli DocumentData

Name

MainBookNo

Code

MainBookNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna HospitalOrderNo tabeli DocumentData

Definicja kolumny HospitalOrderNo tabeli DocumentData

Name

HospitalOrderNo

Code

HospitalOrderNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna PatientName tabeli DocumentData

Definicja kolumny PatientName tabeli DocumentData

Name

PatientName

Code

PatientName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Active tabeli DocumentData

Definicja kolumny Active tabeli DocumentData

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
Mozliwosc edycji naglówka faktury w przypadku gdy faktura zostala blednie wystawiona ale nie zostala zaksiegowana ani przekazana pacjentowi. W takiej sytuacji tabela DocumentData bedzie przechowywac dane historyczne faktury
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InsertDate tabeli DocumentData

Definicja kolumny InsertDate tabeli DocumentData

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna ContractNo tabeli DocumentData

Definicja kolumny ContractNo tabeli DocumentData

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna ExternalContractNo tabeli DocumentData

Definicja kolumny ExternalContractNo tabeli DocumentData

Name

ExternalContractNo

Code

ExternalContractNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna BankAccountID tabeli DocumentData

Definicja kolumny BankAccountID tabeli DocumentData

Name

BankAccountID

Code

BankAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BankName tabeli DocumentData

Definicja kolumny BankName tabeli DocumentData

Name

BankName

Code

BankName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna AccountNo tabeli DocumentData

Definicja kolumny AccountNo tabeli DocumentData

Name

AccountNo

Code

AccountNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ContractorCompanyStatisticalNo tabeli DocumentData

Definicja kolumny ContractorCompanyStatisticalNo tabeli DocumentData

Name

ContractorCompanyStatisticalNo

Code

ContractorCompanyStatisticalNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

REGON kontrahenta dla którego wystawiono fakture


Kolumna ContractorNationalIdNo tabeli DocumentData

Definicja kolumny ContractorNationalIdNo tabeli DocumentData

Name

ContractorNationalIdNo

Code

ContractorNationalIdNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

PESEL kontrahenta dla którego wystawiono fakture


Kolumna OrdererDataId tabeli DocumentData

Definicja kolumny OrdererDataId tabeli DocumentData

Name

OrdererDataId

Code

OrdererDataId

Data Type

NUMBER(15)

Mandatory

No

Comment

 


Lista kluczy tabeli DocumentData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DocumentData

Definicja klucza Identifier_1 tabeli DocumentData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment